Modify Table option
The Schema
Modify Table menu option allows you to change the structure of a table.
When you choose this option, the Data Dictionary alphabetically lists all the tables defined for your database. After you select a table, a window similar to the one shown in Figure 9–1 appears.
See the "Field Editor option" section section later in this chapter for more information on the Field Editor option.
The Modify Table window contains the following fields:
- Table Name
- Area
- Table Type
- Label
- Owner
- Replication
- DataServer Name
- DB Link
- Description
- Hidden
- Frozen
- Dump File
- Record Size
Specifies the name of the table. Table names can be up to 32 characters long and can consist of alphabetic characters, digits, and the characters $, &, #, %, -, and _. In addition, table names must begin with a letter (A–Z or a–z). You cannot use reserved Progress 4GL keywords as table names. Table names are not case sensitive.
Displays the name of the storage area. The Area Name is assigned to a table when it is created. Because the Table Name cannot be updated, this field is disabled.
Displays the table type.
Specifies the label used in error messages.
Displays the user ID of the table owner. This information is necessary for manipulating certain dataservers.
Specifies the name of the procedure that performs the replication for this table. For more information about replication, see the chapter on data replication in OpenEdge Data Management: Database Administration .
Specifies the table name in the appropriate dataserver database if the table is not an OpenEdge table.
Specifies the link name for the distributed ORACLE database.
Describes the table contents.
Specifies if the table is a hidden table. The default value is no.
Specifies if the table is frozen. You can freeze or unfreeze a table using the Freeze/Unfreeze option from the Utilities menu. When a table is frozen, you can only view its properties. The actual record data is not frozen, only the data definitions.
Specifies the file to which you want to dump the table contents. The name must be unique among the other tables in the database and can be up to eight characters long. The default filename is the table name. If the table name is longer than eight characters, the Data Dictionary truncates it to the first eight characters.
Specifies the size of the record used for dataservers with fixed-length records.
The following sections describe the options that appear at the bottom of the window.